package com.ojoin.trade.supplyloan_core.web.dao;

import java.util.List;
import java.util.Map;

import org.springframework.data.domain.Pageable;

import com.ojoin.trade.common.exception.BusinessException;
import com.ojoin.trade.common.web.dao.BaseDao;
import com.ojoin.trade.supplyloan_core.web.domain.TbSlLoanStatTotal;
import com.ojoin.trade.supplyloan_core.web.domain.TbSlLoanStatTotalVo;
import com.ojoin.trade.supplyloan_core.web.domain.TbSlLoanStatTotalVoCompare;

/**
 * Created with IntelliJ IDEA.
 * User: Administrator
 * Date: 15-10-22
 * Time: 上午11:10
 * To change this template use File | Settings | File Templates.
 */
public interface TbSlLoanStatTotalDao extends BaseDao<TbSlLoanStatTotal> {
  
    
    /**
     * 查询电商平台户业务数据统计
     * @param joinuserNo
     * @throws BusinessException
     */
    
    public List<TbSlLoanStatTotalVo> queryTbSlLoanStatTotalByJoinidAndTime(int joinuserNo,String time) throws BusinessException ;

    public  List<TbSlLoanStatTotalVoCompare> queryCompareByPlatformAndMerchantUserIDAndDate(Map<String, Object> paramap,Pageable page);
    
    public  List<TbSlLoanStatTotalVo> queryByPlatformAndMerchantUserIDAndDate(Map<String, Object> paramap)throws BusinessException;
    
    
    public void deleteTbSlLoanTotalByPlatformUserIDAndDate(int platformUserId, String statDate) throws BusinessException;

    public List<TbSlLoanStatTotalVo> queryLoanTotalByJoinidandPlatform(int idOfTbMerchantUser,int idOfPlatformUser,Pageable page )throws BusinessException;
    
    public TbSlLoanStatTotal queryByPlateIdAndTime(String plateId, String time) throws BusinessException;
    String getLastInsertTime(int platformAccountId);
}
